﻿CREATE TABLE [common].[MarketIdentifier] (
    [Id]          BIGINT          IDENTITY (1, 1) NOT NULL,
    [CountryCode] NCHAR (2)       NOT NULL,
    [ParentCode]  NCHAR (4)       NULL,
    [Code]        NCHAR (4)       NOT NULL,
    [Name]        NVARCHAR (128)  NOT NULL,
    [Acronym]     NVARCHAR (32)   DEFAULT ('') NOT NULL,
    [City]        NVARCHAR (128)  DEFAULT ('') NOT NULL,
    [Website]     NVARCHAR (2048) DEFAULT ('') NOT NULL,
    [Comments]    NVARCHAR (4000) DEFAULT ('') NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

